How to load Crosstable with limited columns as data and others are as qualified?

[ishanbhatt]

Hi All,

I am trying to load data using cross table.

I've used qvd for data load and my data looks like

In Cross table Name and Product fields i select for the Qualifier and the other columns as Attribute fields.

Instead of this I want to use Name, Product, City and Country as Qualified field, Jan amount and Feb amount as attribute fields.

I want to load data

Please help me out,

Thanks in advance

Ishan Bhatt

[sunny_talwar]

Maybe this:

Table:

CrossTable(Month, Data, 4)

LOAD Name,

          Product,

          City,

          Country,

          [Jan Amount],

          [Feb Amount]

FROM Source;

[Anonymous]

Try what Sunny suggested you...

Another workaround is like say Jugad?

Insert all the attribute field as last column in excel as with above mentioned structure you would not be able to Qualify City & country.

[Anonymous]

try this at script, slightly reorder the columns..

CrossTable(Month,Sales,4)

LOAD

NAME,

PRODUCT,

CITY,

COUNTRY

Jan,

Feb

FROM

(ooxml, embedded labels, table is Sheet1);

[ishanbhatt]

Thanks you so much Sunny and Balraj to give response.

It Works. Thanks once again.

Ishan

[ishanbhatt]

Thanks you so much Sunny & Balraj.

It's work.

Ishan