Let’s say I have the following table
A
B
C
E
F
H
I
J
I want to insert rows for the missing letters in sequence…in this case “D” and “G”
How would I do this?
Let’s say I have the following table
A
B
C
E
F
H
I
J
I want to insert rows for the missing letters in sequence…in this case “D” and “G”
How would I do this?
Hi @Robert
If you’re trying to insert rows, I recommend using a combination of the “Insert row numbers”, “Filter rows”, “Insert rows”, and “Stack tables” steps.
Here’s an example flow mocked out:
Source data:
Inserting row numbers:
Filter rows up to each missing keyword:
Here is the top “Filter rows” step (A - C)
Here is the middle “Filter rows” step (E - F)
Here is the bottom “Filter rows” step (H and above)
Insert row numbers to fill in missing keywords:
Stack the datasets back together:
Let me know if that helps!
Thanks @daniel,
But I don’t know which letters are going to be missing each time, so I can set a static keep until row 3 or whatever.
Robert
That makes sense! Can you tell me a bit more about your end goal here? Are you simply trying to fill in a list of missing keywords?
If so, could you create a reference table with all of the keywords, use a “Combine tables” step to keep all rows from your reference table, and only matching rows from your initial table?
Here’s an example of your reference table with all of the keywords (letters):
After the source data, I’m using an “Insert text column” step to help indicate which table we’re merging from.
Finally, the “Combine tables” step will insert all missing keywords into your table.
Let me know if that’s a potential workaround!
OK, thanks for your suggestion. The JSON data I’m getting, after cleaning it up, is in a single column. Like this.
A
100
B
20
C
D
500
E
30
F
G
250
What I need is two columns like this.
A 100
B 20
C
D 500
E 30
F
G 250
A-G never change, but their values do, and the blanks (no value) do as well.
I hope that helps.
Hey @Robert,
I made this quick Loom video to walk you through how I might set that up.
Let me know if this is helpful!
Genius level!!! Thanks so much, @daniel