Datatable Joins

[WorkingForFood]

I have two DataTable variables in PAD and need to join them. Is there a way to do this in PAD without using a SQL database?

[ZS440]

@WorkingForFood 

The number of columns needs to be the same.

try it sample.

SET NewVar TO {[1, 2, 4], [6, 7, 8] }
SET NewVar2 TO {[8, 2, 4], [6, 7, 8], [5, 6, 7] }
LOOP LoopIndex FROM 0 TO NewVar2.RowsCount - 1 STEP 1
SET NewVar TO NewVar + NewVar2[LoopIndex]
END

[WorkingForFood]

Thanks for the reply @ZS440 , but it looks like your solution produces a UNION, but I'm looking for a JOIN (specifically LEFT JOIN).

[cfoenki]

Hi @ZS440 , I know that this is an old post but your solution would be exactly what I need.

But I failed to apply it.

When I apply the last Set variable action, it is like this:

On your screen you don't have the ' among the +.

How did you get that?

Thank you in advance.

[ZS440]

@cfoenki 

%NewVar% + %NewVar2[LoopIndex]%

Note the "%" and try writing

%NewVar + NewVar2[LoopIndex]%

[cfoenki]

You're my hero! 🙂