on 04-23-2015 6:09 AM
Hello All,
Could anyone give me more details about using crosstab? I never used crosstab action block in MII workbench.
Here is what I have in my XMLOutput.
Plant Qty MaxQTy
1001 1500 15000
1002 500 1000
1002 10000 15000
1004 0 12000
I need the output like this
Plant | Qty | MaxQTy |
1001 1500 15000
1002 10500 16000
1004 0 12000
In the Crosstab action block I was mentioning Document output in the Document Source and in the Crosstab columns I mentioned Matnr column. How to get the Aggregate Qty and Max Qty by material?
Thanks,
Latha
Hi Latha,
In simple terms, cross tab does a addition of columns based on one or more(max 4) specific column's value. So the intended result would be achiveable using crosstab.
Set Plant as your crosstab column.
Thanks,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Latha,
I am able to get the result. PFB the screenshot:
Input:
CrossTab Column 1 = Plant, Output:
Last column in the output gives sum of all plants.
Please note, crosstab considers numeric columns(SQLDataType="6") only for operation. You are not getting it probably because the datatype is different.
Best Regards,
Swaroop
User | Count |
---|---|
11 | |
6 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.