How can i concatenate n number of tables ?

[#1]

how can i concatenate n number of tables in one shot? every table will differ in column names

Please help me

[Chanty4u]

hi

Load Multiple Tables

[its_anandrjs]

If file formats are exactly same then tr with this

https://community.qlik.com/docs/DOC-14663

Regards

Anand

[Anonymous]

Hi,

Have a look at: Understanding Join, Keep and Concatenate

[Anonymous]

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

[gireesh1216]

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

]

[#7]

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

) 

[jyothish8807]

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