Extracting Particular String from headers of a dataset

[sriniprad08]

Hi Team,

I need a help. Please find below the input and the expected output.

Please let me know your thoughts,

Thanks

Sri

INPUT	OUTPUT
BKPF.BUKRS Société	BUKRS
BKPF.BELNR Numéro de pièce comptable	BELNR
BKPF.GJAHR Exercice comptable	GJAHR
BKPF.BLART Type de pièce	BLART
BKPF.BLDAT Date de la pièce	BLDAT
BKPF.BUDAT Date comptable de la pièce	BUDAT

[KarolinaRoza]

hi @sriniprad08 

I suppose in your input you  are having one row of data in one cell(for example there is white space between  BKPF.BUKRS and Société), right?

If yes, attached workflow should work.

Regards,

Karolina

[sriniprad08]

Hi @KarolinaRoza ,

Thank you so much . Really appreciate the help. It's working. But i am stuck at one place if you can help. My data is in the below format. Is it possible in Alteryx to just replace the headers using regex and keep the data intact? otherwise i have to first do regex and manually copy paste the headers.

Thanks,

Sri

BKPF.BUKRS Société	BKPF.BELNR Numéro de pièce comptable	BKPF.GJAHR Exercice comptable	BKPF.BLART Type de pièce	BKPF.BLDAT Date de la pièce
3000	0343	2019	RV	10/01/2019
3000	343	2019	RV	10/01/2019

[KarolinaRoza · Accepted solution]

hi @sriniprad08 ,

You do not need to do it manually 🙂

You can apply Dynamic Rename tool:

[sriniprad08]

Hi @KarolinaRoza ,

Thank you so much 🙂 . Very useful.

Regards,

Sri