How to add comment from CrossTable? URGENT HELP please

[#1]

Hi,

I have straight table whihc will get data from excel file. I used CrossTable. All is fine. I would need to add the Comment in the Straight table.

can anyone help me how to do this please.

Thanks.

[#2]

please find sample attached.

[its_anandrjs]

Hi,

Means a column or any message. Let me know please.

Thanks & Regards

[#4]

Thanks. It is column in excel file but because of CrossTable it is shown under Result in qvw

[its_anandrjs]

Hi,

Add that column in your straight table as dimension and check it i think the data is shown there please check

Hope this helps

Thanks & Regards

[#6]

Yes you are right. I used belwo expression nand I can able to see comment

If(Result<>'Pass',Result)

But in the comment it is shwoing '-'. How can I remove dashes. I, e how can I change above expression to remove '-'

[Gysbert_Wassenaar · Accepted solution]

Do you mean like this?

Goods:

CrossTable(Item,Result,5)

LOAD [Date Reviewed],

     Member,

     Reference,

     Outcome,

     Comment,

     bfbwt,

     btbtefb,

     bgfdbsvsfeb,

     fbfdbf,

     vfd     

FROM

V.xlsx

(ooxml, embedded labels, table is Sheet1);

[#8]

Thanks. Up to crosstable it is ok. As I can able to see Comment as separate now. But it is not populating in Straight table it is showing Blanks. Please help.

[its_anandrjs]

Can you share a snapshot of straight table.

Thanks & Regards

[#10]

Perfect I got it . Thanks.