There is a QlikView document with separate "City" and "State" fields A system administrator needs to create separate QVW documents each with a singular "City and State" field.
I'm not sure why we need to loop and reduce at all. Couldn't we just concatenate the 'City' and 'State' fields and be done with it? That would give us the singular 'City and State' field we're looking for.
Option C seems the most straightforward. Concatenating the 'City' and 'State' fields and then looping and reducing by the combined 'City and State' field is a logical approach.
Cristina
1 days agoDortha
4 days agoHannah
8 days agoGertude
10 days agoHannah
11 days ago