topic Re: Need Help?? in QlikView

Need Help??

paulwalker — Wed, 18 Feb 2015 04:19:58 GMT

HI Community,

I need one clarification..

I have 2 same table structure,

First table master table and second table depending on 1st table based on Policy ..

i want compare with only Policy Id. i want to give left join only

and remaining fields should be concatenate with both tables.

i don't want to rename second tables names....

Emp:

LOAD Country,

Location,

Client,

[Policy],

Employee,

Currency,

Month,

Year

FROM

(qvd);

Left Join

Cust:

LOAD Country,

Location,

Client,

[Policy],

Employee,

Currency,

Month,

Year

FROM

(qvd);

Hope you understand...

Thanks in Advance..........

Re: Need Help??

PrashantSangle — Wed, 18 Feb 2015 04:25:06 GMT

Hi,

Without renaming its not possible.

Better if you post sample data with expected output.

Regards,

Re: Need Help??

fashid — Wed, 18 Feb 2015 05:01:45 GMT

Hi,

Please post sample app

Regards,

Nadeem

Re: Need Help??

avinashelite — Wed, 18 Feb 2015 05:09:54 GMT

Hi Paul,

You can try the other way use EXIST condition in the second table using policy ID so it will load only the Policy id which is present in the 1 master table and it con-cat automatically

Re: Need Help??

Wed, 18 Feb 2015 05:15:34 GMT

You can try adding Table resp. flags to identify data and then play around in the script.

Try something like:

Emp:

LOAD Country,

Location,

Client,

[Policy],

Employee,

Currency,

Month,

Year,

'From Master' as TableFlag

FROM

(qvd);

Concatenate

Cust:

LOAD Country,

Location,

Client,

[Policy],

Employee,

Currency,

Month,

Year,

'From Employee' as TableFlag

FROM

(qvd);

Hope this answered you query or was helpful.

Thanks,

Singh

Re: Need Help??

fashid — Wed, 18 Feb 2015 05:21:32 GMT

Hi,

Avinash is correct I guess this should solve it .

Regards,

Nadeem