Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Need Help??

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..........             

5 Replies
PrashantSangle

Hi,

Without renaming its not possible.

Better if you post sample data with expected output.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
fashid
Specialist
Specialist

Hi,

Please post sample app

Regards,

Nadeem

avinashelite

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 

Not applicable

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

fashid
Specialist
Specialist

Hi,

Avinash is correct I guess this should solve it .

Regards,

Nadeem