How to append multiple columns from different sheet into one signal data in alteryx

Question

hello Everyone,

Need urgent help on below mention use case :

How to append multiple columns from different sheet into one signal data in Alteryx.

number of sheets dynamic and columns as well.

Thanks in advance !

sample input and output

Output:

ABCDEAA_Sheet1_FAA_Shhet1_GAA_Sheet1_HBB_Sheet1_IBB_Sheet1_JBB_Sheet1_KBB_Sheet1_LBB_Sheet1_MBB_Sheet1_OCC_Sheet1_NCC_Sheet1_PCC_Sheet1_QCC_Sheet1_RCC_Sheet1_SAA_Sheet2_XAA_sheet2_YAA_sheet2_ZBB_sheet2_OBB_Sheet2_PBB_Sheet2_QBB_Sheet2_RCC_Sheet2_BBCC_Sheet2_BECC_Sheet2_ED

Input :

Sheet 1

AABBCCABCDEABCDEABCDEABCD

Sheet 2,

AABBCCABCDEXYZOPQRBBBEED

CoG · Answer

Here is a sample workflow based on some assumptions about how your data would need to be laid out to make sense:

Main Workflow:

Batch Macro:

Sample Workflow.yxzp

Ekmi9 · Answer

Sorry I can not share any sample data but in every sheet i have different sub column and on top of that i have different main headers (like AA is main Header and FGH sub Header under that)

AABBCCABCDEFGHIJKLMNOPQRS

Raj · Answer

Please share some more details about the requirements also as @binu_acs  said correctly it will be better if you can provide some sample data as well