How to add selection into load statement

[#1]

I need help, how to put the following logic into load statement. Shouldn't be rocket science, but I just can't get it right! 🙂

I am first loading table 1 (header) with load statement :

TABLE1:

Load

ID

FROM A1.qvd;

I know that there is only 1 ID in the source, which keeps changing every minute. Next I need to load only that ID into table 2.

TABLE2:

Load

ID,

Date,

TIME

FROM

B1.qvd;

How can I select to load only the data with ID from table 1, into table 2?

[#2]

If I understand your problem correctly, you need to do a resident:

TABLE2:

load x,

y,

z

resident TABLE1;

[#3]

Yes, but how to do the syntax in my case? I have fields ID, Date & TIME in my data...

[#4 · Accepted solution]

Use JOIN between table...

TABLE1:

Load

ID

FROM A1.qvd;

TABLE2:

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

B1.qvd;

[#5]

Thank you! This was, what I was looking for!

[#6]

For some reason I am not able to load more than one table using inner join. I would like to read in the 1st table as a validator for the rest of the tables B1, C1 etc. So basically:

TABLE1:

Load

ID

FROM A1.qvd;

TABLE2:

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

B1.qvd;

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

C1.qvd;

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

D1.qvd;

[#7]

For some reason I am stuck with a similar problem again. I have 2 identical files (Danish_customers, Other_Customers). I would need a report to compare which Customers exist both in Danish_customers and Other_Customers. Something like this:

Danish_customers:

LOAD

CUSTOMERID,

CUSTOMERNAME

FROM Danish_customers.xlsx;

Other_Customers:

INNER JOIN(Danish_customers)

LOAD

CUSTOMERID,

CUSTOMERNAME

FROM Other_Customers.xlsx;

For some reason I end up with a report including ALL customers (All Other+Denmark) instead of getting a list of just the customers that exist both in Denmark and other places. What is it I am doing wrong here?

Example of the data:

Danish_customers:

CUSTOMERID CUSTOMERNAME

1234 Johnny Appleseed

2345 Jorgos Aviorikos

....

Other_customers:

CUSTOMERID CUSTOMERNAME

B3203 John Smith

2345 Jorgos Aviorikos <-- same as in Danish_customers

....

In this case I would like to collect only the customer 2345 in my final report.

[bismart]

Try this simpler approach using 1 table...

Customers:

LOAD
CUSTOMERID,
CUSTOMERNAME,
'DANISH' as [Customer Type]
FROM Danish_customers.xlsx;

LOAD
CUSTOMERID,
CUSTOMERNAME,
'OTHER' as [Customer Type]
FROM Other_customers.xlsx;

Create report

Dimension: CUSTOMERID
expression: count([Customer Type])

Sort by expression descending...