topic Re: Need Suggetion.... in QlikView

Need Suggetion....

agni_gold — Mon, 04 May 2015 06:57:24 GMT

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

Re: Need Suggetion....

tresB — Mon, 04 May 2015 07:02:27 GMT

Perhaps, Concatenate ?

Re: Need Suggetion....

datanibbler — Mon, 04 May 2015 07:06:41 GMT

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

Re: Need Suggetion....

Mon, 04 May 2015 07:12:48 GMT

Hi Agnivesh,

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

Regards,

Chennaiah

Re: Need Suggetion....

agni_gold — Mon, 04 May 2015 07:15:35 GMT

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

Re: Need Suggetion....

Mon, 04 May 2015 07:19:35 GMT

Yes.

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

so no need to use qualify statement.

Re: Need Suggetion....

agni_gold — Mon, 04 May 2015 07:23:10 GMT

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

Re: Need Suggetion....

datanibbler — Mon, 04 May 2015 07:23:42 GMT

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.

Re: Need Suggetion....

datanibbler — Mon, 04 May 2015 07:25:12 GMT

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

Re: Need Suggetion....

agni_gold — Mon, 04 May 2015 07:29:58 GMT

Yes

Re: Need Suggetion....

Mon, 04 May 2015 07:33:15 GMT

It's OK.

Chennaiah