Load Data Dependent on Values from Previous Table

[Meghann_MacDonald]

Hi all,

I want to only load values from Table B that are labeled 'Lead' in Table A.

Ex:

[Table A]:

LOAD

[Registration Email],

[Status],

[user_id]

From ABC;

[Table B]:

email as [Registration Email],

Alternate data (leadinfo, etc)

From XYZ (where the email in Table A is listed as 'Lead' for [Status];

Is this possible?

Meghann

[QFabian]

HI @Meghann_MacDonald , it is posible, you can use exists function in where of second load :

[Table A]:

LOAD

[Registration Email],

[Status],

[user_id]

From ABC

Where Status = 'Lead'; //do this or create another table with the values needes (Status = 'Lead')

[Table B]:

email as [Registration Email],

Alternate data (leadinfo, etc)

From XYZ

where exists([Registration Email], email);

[Meghann_MacDonald]

I think this works perfectly. Nifty trick I will use later on. It does create a bit of roundabout loading but it seems like that is the best way to get what I need. Thank you so much!

[Meghann_MacDonald]

Hi Anil, the destination table is just what I would LIKE to be able to pull. I just used Tiago's process to do this of loading a temp table from A with only the emails I want, and then loading B with a left keep of (temp). This worked.

I don't have experience loading inline like you listed and I have >8,000 emails so I'm not sure that would work...

Thank you for the help!