# \#flexijoins

**URL:** https://discourse.julialang.org/tag/flexijoins/1043.md

[Latest](https://discourse.julialang.org/latest.md) · [Categories](https://discourse.julialang.org/categories.md) · [Tags](https://discourse.julialang.org/tags.md)

---

## [Left join algorithm for columnar tables](https://discourse.julialang.org/t/left-join-algorithm-for-columnar-tables/122725)

<div class="topic-metadata">

**Author:** [@memosik97](https://discourse.julialang.org/u/memosik97)\
**Replies:** 4\
**Last updated:** [November 18, 2024, 1:20am UTC](https://discourse.julialang.org/t/left-join-algorithm-for-columnar-tables/122725 "2024-11-18T01:20:36Z")

</div>

Hello I’m making custom Tables (Dict{Symbol, Vector} basically) since there seems to be no library matching my needs (columnar tables optimized for data insertions). I’m just a beginner (few days into Julia). I have a w…

---

## [Conditional left join 2 dataframes when none of the columns are common](https://discourse.julialang.org/t/conditional-left-join-2-dataframes-when-none-of-the-columns-are-common/81401)

<div class="topic-metadata">

**Author:** [@vtomar](https://discourse.julialang.org/u/vtomar)\
**Replies:** 26\
**Last updated:** [May 26, 2022, 6:28pm UTC](https://discourse.julialang.org/t/conditional-left-join-2-dataframes-when-none-of-the-columns-are-common/81401 "2022-05-26T18:28:31Z")

</div>

df1 = DataFrame(id = \[1,101,1001\], b = \[1,2,3\]) df2 = DataFrame(id1 = \[0, 95 \], id2 = \[50, 150 \], c = \[2,3\]) I want to conditionally left join df1 and df2 such that id1 \< id \< id2 and all the rows in df1 appear in t…