Rearrange row in a straight table

[qvhjenvo]

Hi,

I have a straight table for ex. below

GarNo	Buyer	ledger_prospect_date	Applicationdate	Amount1	Amount2
301016	Buyer1	20151008	08.10.2015	0,00	-
301016	Buyer1	-	-	34,61	34,61
300138	Buyer2	20130222	22.02.2013	0,00	-
300138	Buyer2	-	-	466,28	486,56

So I want to rearrange so that a new table:

GarNo	Buyer	ledger_prospect_date	Applicationdate	Amount1	Amount2
301016	Buyer1	20151008	08.10.2015	34,61	34,61
300138	Buyer2	20130222	22.02.2013	466,28	486,56

Some ideas to help?

Thanks in advance

[arthur_dom]

In layout or scripting?

[#3]

Hi,

It looks like ledger_prospect_date is a dimension in your straight table. Please tick the check-box 'suppress when value is null' for it.

[alexdataiq]

Asuming that the dashes "-" are null/missing values in your data you could maybe do something in scripting:

I attached a little example.

Regards.

[MarcoWedel]

Hi,

instead of correcting your straight table you might wish to correct your data model.

Can you provide your script and some sample data to test alternatives?

thanks

regards

Marco

[qvhjenvo]

Hi, Arthur

For in layout.

I am interested for both.

[qvhjenvo]

I can not see your attachment. Can u send it again?

Regards

[amayuresh]

I am not able to open your application.

Please can you provide sample data and What is Amount1 and Amount2  ?