Covert data in one table to 3 different table

Question

I have one big table want to convert it in 3 different table in one sheet only please see below input and expected output.

any thoughts on this?

Input Table

Payment TypeAccount Receivable DetailsAmount Payable (GBR)Salary101100Tax101100National Insurance 101100Apprenticeship Levy101100Rounding difference 100Pen 100Salary101100]Tax101100National Insurance 101100Apprenticeship Levy101100Rounding difference 100Pen 100Salary101100Tax101100National Insurance101100Rounding difference 100Pen 100

Expected Output

Reporting Location:abc       Payment TypeAccount Receivable DetailsAmount Payable (GBR) Salary101 £100.00 UK Tax101 £100.00 National Insurance 101 £100.00 Apprenticeship Levy101 £100.00 Rounding difference  £100.00 Pen  £100.00             Reporting Location: abc           Payment TypeAccount Receivable DetailsAmount Payable (GBR) Salary101 £100.00 UK Tax101 £100.00 National Insurance 101 £100.00 Apprenticeship Levy101 £100.00 Rounding difference  £100.00 Pen  £100.00             Reporting Location: abc       Payment TypeAccount Receivable DetailsAmount Payable (GBR) Salary101 £100.00 UK Tax101 £100.00 National Insurance 101 £100.00 Rounding difference  £100.00 Pen  £100.00

videet · Answer

@ChrisTX

I have generated all the data i just want to configure input data as shown earlier like below screenshot

As in input data you can see all the data is under one header i want to spilt it in 3 different table as below

ChrisTX · Answer

In your input data there are 3 rows with data   Salary    101    100

Will those 3 rows always be the same?  If they are not the same do you want the workflow to generate an error or just use the first occurrence and ignore the others?

Try this:  Use a Unique tool on all 3 fields, then a Formula tool to correctly format Amount Payable as a string and include the Pound symbol and decimal.

I'm guessing the data type for the Amount Payable field is numeric?  You will need to create a new field to change the data type using a Formula tool. Then you can use a Select tool to drop the original field and re-name the new field.

Use a formula like  "£" + ToString([Amount Payable], 2)

Here is a list of all functions:  https://help.alteryx.com/current/designer/functions

Chris