Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Need Suggetion....

Hi All ,

I have data source in which multiple tables are prese3nt , and all tables have lot of columns (Approx. 200) in each table . And about 100 column names are same in the tables.

So to remove the synthetic key I can do the following solution  :

        1 : Renaming the field

         2 : Using Qualify Function

But renaming fields is not a good option it will take lot of time .

And Client requirement is , not to use the qualify function.

So can you all suggest me any other way to do this .

Thanks

10 Replies
tresesco
MVP
MVP

Perhaps, Concatenate ?

datanibbler
Champion
Champion

Hi Agnivesh,

I would advise against using QUALIFY anyway, it brings you only trouble in the long run.

I know of no third alternative - then you have to rename fields.

It's not so much work in the overall view of things because you have to do it only once.

Or you could load all tables with QUALIFY, load a mapping table with the qualified names and a chosen alias, then use MAP USING and do a RESIDENT LOAD for each table with UNQUALIFY - but that would be even more work 😉

Sorry - I guess you'll have to choose one frog or the other ...

Best regards,

DataNibbler

Not applicable

Hi Agnivesh,

Create resident tables with fields currently u r using in application and concatenate all resident tables and drop mail tables.

Regards,

Chennaiah

agni_gold
Specialist III
Specialist III
Author

If I will use Concatenate then my data model will be of 1 table

Not applicable

Yes.

with all fields which r currently u r using. in single table.

so no need to use qualify statement.

agni_gold
Specialist III
Specialist III
Author

So is this ok that for my big dashboard data model only one table is present .

datanibbler
Champion
Champion

Hi Agnivesh,

just a word of caution: Do you know for sure that the equally named columns also have the same meaning in all of the tables? (If the tables were to come from SAP, for ex., that would not necessarily be the case)

The other requirements - same no. of columns and same structure - are easy probably.

datanibbler
Champion
Champion

If it works, it is probably okay 😉 It's in some aspects est possible solutions - response times will be optimally short with just one table.

Best regards,

DataNibbler

agni_gold
Specialist III
Specialist III
Author

Yes