Hi Folks!! I am getting input files where structure of the input file is not in sync as shown below Format - 1 Organization Data2Corporate Data 1 Weeks123 Hours347 Format - 2 Corporate ABC Weeks1234 Hours2232 Format - 3 ANCData Weeks123 Hours 4 2 2 I need to pick data above highlighted in RED, i.e only for the Rows and Columns where we have WEEKS and HOURS as a text no matter where it is available. Please suggest how to achieve this in Alteryx. Note - I don't have column Header in any of the format Thanks A

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

How to pick the data from dynamic columns

Hi Folks!!

I am getting input files where structure of the input file is not in sync as shown below

Format - 1

		Organization
	Data2	Corporate
Data 1		Weeks	1	2	3
		Hours	3	4	7

Format - 2

	Corporate
ABC	Weeks	1	2	3	4
	Hours	2	2	3	2

Format - 3

ANC	Data	Weeks	1	2	3
		Hours	4	2	2

I need to pick data above highlighted in RED, i.e only for the Rows and Columns where we have WEEKS and HOURS as a text no matter where it is available.

Please suggest how to achieve this in Alteryx.

Note - I don't have column Header in any of the format

Thanks

Developer

Accepted answers

binu_acs

@amsrivastava

dynamic_header_07052024.yxzp

All comments

aatalai

@amsrivastava does the attached workflow help?

How to pick the data from dynamic columns.yxmd

binu_acs

@amsrivastava

dynamic_header_07052024.yxzp

Quick Links

Unanswered
Community Events
Groups

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235