Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening to all!!!
I need to create a single list in table 1, from 2 columns that have different names, from 2 different tables, can someone take a look to the image and give me a hand?
Simplify doing this? Flag will help, Which data source it is picking
T1:
LOAD *, 'T1' as Flag Inline [
ID1, Name1
A, AA
B, AA
C, AA
];
T2:
LOAD ID2 as ID1, Name2 as Name1, 'T2' as Flag Inline [
ID2, Name2
1, 11
2, 22
3, 33
B, AA
];
Hi, this is an example for bigger tables that contain many more columns, what I need to understand is how to get in table 1 the other lines from table 2
Hi, thank you for your help, what I'm trying to understand is how to get in table 1 the lines / data from table 2 with out getting repeated values in table 1.
This is a ver simple example for a much bigger tables that contains many more columns.
It worked perfectly!!!!!!! Thank you very much and sorry for my Spanglish
Hi
On the next image the point where I´m stuck, can you give me a hand with the script and where to add it?
Once again thank you very much!!!