Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Split Rows into Mutliple Row

patz007
5 - Atom

Hi Team, I have a query on splitting the row into two rows when there are amounts in both debit and credit accounts. If the amount is 0 on either account leave the row and don't split for the same batch ID. Please help me with the issue, I really appreciate it.

 

Here is an example:

 

Batch IDAccount IDAccount NameDebit Credit
100120001Loan Account500500
100120002Settle Account0500

 

OutPut:

 

Batch IDAccount IDAccount NameDebit Credit
100120001Loan Account5000
100120001Loan Account0500
100120002Settle Account0500
3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @patz007,

Think this is what your looking for:

IraWatt_0-1652983397113.png

Any Questions please ask :)

HTH,

Ira

 

DQAUDIT
9 - Comet

@patz007 

 

Sounds like the suggestion by @IraWatt  should work, but in case you wanted options here is another approach:

 

  • Use a Transpose tool and mark BatchID, Account ID, and Account Name as your  Key fields.  Then use Debit and Credit as your Data columns.
  • Add a Filter tool to remove zeroes (not sure if negatives appear in your data)
  • Add a Record ID tool.
  • Then Cross Tab back grouping by batchID, AccountID, AccountName, and RecordID.  For the Column Names you can use use the Name field and for the Values use the Value field

 

Good luck!

 

grazitti_sapna
17 - Castor

@patz007, try this.

 

grazitti_sapna_0-1653019210635.png

Thanks!

Sapna Gupta
Labels