Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can i concatenate n number of tables in one shot? every table will differ in column names
Please help me
If file formats are exactly same then tr with this
https://community.qlik.com/docs/DOC-14663
Regards
Anand
Hi,
Have a look at: Understanding Join, Keep and Concatenate
In every table just create one more field like 'Direct' as Fact_type, in the 2 nd table 'Indirect' as Fact_type
just like a flag and concatenate all 3 table into one
TABLE1:
LOAD * INLINE [
A,B
1,2
]
concatenate(TABLE1)
TABLE2:
LOAD * INLINE [
C,D
3,4
]
concatenate(TABLE1)
TABLE3:
LOAD * INLINE [
E,F
5,6
]
Hi Chanty,
Thanks for ua reply. In that example they explained about loading complete column..But i want to know how to load complete file of jobs(lets say 100 tables at once
)
Hi Yoges,
One way could be by creating a procedure. Call all the tables in the procedure and then in a single go you can concatenate.
Br,
KC