Alteryx Designer Desktop Discussions

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

Data transformation

RajatRehria
8 - Asteroid

Hi team, can someone please help me transforming data like below:

 

Input

ABC-DL    12345 ABC BANK, LLC               A/C 12345B817413
DEL BR    00123 12345 ABC BANK, LLC               A/C 
DDA CONTROL# 123456789                                                PET LOP/FEE
TRADE DATE 12/01/2022        SETTLE DATE 01/12/2023     ISSUE DATE
CUSIP/VER  01E062794       SECTYPE/CORPORATE-DEBT     DAYS INTEREST
URF-FV     57,000,000.00000 
PRICE IN USD       102.63125 
PRINCIPAL     57,413,742.5 
NET AMT        57,413,742.5 

 

I want the above data to be transformed like below output. Thanks.

 

 

Output (Position of the columns don't matter)

ABC-DLA/CDEL BRDDA CONTROL#TRADE DATESETTLE DATECUSIP/VERURF-FVPRICE IN USDPRINCIPALNET AMT
12345 ABC BANK, LLC12345B81741300123 ABC BANK, LLC12345678912/01/202201/12/202301E06279457,000,000.00102.6312557,413,742.50

57,413,742.50

1 REPLY 1
Hamder83
11 - Bolide

Its not pretty ....

Labels