Subfield to separate columns mapping values

mwscott1 — Fri, 10 Sep 2021 11:46:02 GMT

In the load statement how do I make this column

What has contributed most to your production or success to date?

Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.) ;Technology (i.e. Agent Assist, virtual enrollment tools, etc.)

Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.)

Training (Foundations Class, Opener GPS, etc.) ;Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.) ;Understanding of compensation;Ability to gain new accounts

Training (Foundations Class, Opener GPS, etc.) ;Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.)

Training (Foundations Class, Opener GPS, etc.)

Training (Foundations Class, Opener GPS, etc.) ;Understanding of compensation

Look like this

Option1	Option2	Option3	Option4	Option5
	Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.)	Technology (i.e. Agent Assist, virtual enrollment tools, etc.)
	Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.)
Training (Foundations Class, Opener GPS, etc.)	Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.)		Understanding of compensation	Ability to gain new accounts
Training (Foundations Class, Opener GPS, etc.)	Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.)
Training (Foundations Class, Opener GPS, etc.)
Training (Foundations Class, Opener GPS, etc.)			Understanding of compensation

Re: Subfield to separate columns mapping values

sunny_talwar — Fri, 10 Sep 2021 15:41:44 GMT

Try something like this

OptionMapping: Mapping LOAD F1, '@' & F2 & '@'; LOAD * INLINE [ F1, F2 Training, Option 1 Support, Option 2 Technology, Option 3 Understanding, Option 4 Ability, Option 5 ]; Table: LOAD [What has contributed most to your production or success to date?], Value, TextBetween(MapSubString('OptionMapping', Value), '@', '@') as Option; LOAD [What has contributed most to your production or success to date?], Trim(SubField([What has contributed most to your production or success to date?], ';')) as Value; LOAD * INLINE [ What has contributed most to your production or success to date? "Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.) ;Technology (i.e. Agent Assist, virtual enrollment tools, etc.)" "Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.) " "Training (Foundations Class, Opener GPS, etc.) ;Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.) ;Understanding of compensation;Ability to gain new accounts" "Training (Foundations Class, Opener GPS, etc.) ;Support from sales team (Coaching sessions, joint field work, ongoing communication, etc.) " "Training (Foundations Class, Opener GPS, etc.) " "Training (Foundations Class, Opener GPS, etc.) ;Understanding of compensation" ]; FinalTable: LOAD Distinct [What has contributed most to your production or success to date?] Resident Table; FOR i = 1 to FieldValueCount('Option') LET vOption = FieldValue('Option', $(i)); Left Join (FinalTable) LOAD [What has contributed most to your production or success to date?], Value as [$(vOption)] Resident Table Where Option = '$(vOption)'; NEXT DROP Table Table;

topic Re: Subfield to separate columns mapping values in App Development

Subfield to separate columns mapping values

Re: Subfield to separate columns mapping values