Need help in expression

[#1]

Hi all,

Please find the attached snap shot.

In my application moevement type 106 have two 105 records.and system is not maintained proper linking.

but still I want remove where ever 105 double entries and 106 single entries.

Please help..........

Thanks & Regards

Surender

[sinanozdemir]

Hi Surender,

I am not sure where you want to achieve this, in the front end or in the back end. Here are the solutions for both:

In the front-end, you can achieve this by RowNo() function:

In the back-end, you can use Previous() function:

And your data model will look like this:'

Hope this helps.

[#3]

Hi

Thanks for your reply.

Actually Script change values are different.

please find the attached snap shot

Fact table like below

RefereceKey, [Material Doc 106],Quantity105,[Material Document1]

HK03 ,5005134977 ,12500, 5005134976

         ,                , 12500,5005180235

Please help

Thanks & regards

Surender

[sasiparupudi1]

please post your application

[sinanozdemir]

Hi Surender,

You have a totally different snap shot then what you originally posted. I suggest you either post a sample dataset or an application so that we can understand better your requirements.

Thanks

[kaushiknsolanki]

Hi,

Try this.

Load Distinct

RefereceKey, [Material Doc 106],Quantity105

From XYZ;

Regards,

Kaushik Solanki