Not load field

[priyarane]

Hi Community,

I don't wanted to load particular field for the below scenario.

I have 2 tables

1. TabA

Fields:

A,

B,

C

2. TabB

Fields:

A,

B

Now in dashboard I am loading table like below.

Table:

Load * From Tab*;

Now I am getting synthetic keys so I don't wanted to load Field C by using

Table:

Load * From Tab*

where ?;

How can I achieve this scenario.

- Priya

[Kushal_Chawda]

I am still unclear but can't you comment the field C from table and then load it?

[engishfaque]

Dear Priya,

You can do it by using, Comment, Rename, Alias, Qualify/UnQualify or Drop your Field "C".

Kind regards,

Ishfaque Ahmed

[priyarane]

Hi Kushal,

I have to use like

Load * From Tab*

[Kushal_Chawda]

If you don't have same number of field with same name then FROM tab* will not work. But still you can use loop to concatenate the same.

[priyarane]

Hi Kushal,

Do you have sample Loop

[Kushal_Chawda]

Data:

LOAD * inline [

Junk ];

For each vFileName from filelist('path\*.qvd')

Concatenate(Data)

LOAD *

FROM $(vFileName )(qvd);

NEXT vFileName ;

drop field Junk;