Transpose every n Rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Friends,
I have a table as below. I need to transpose every 4 Columns into a table . Can you please help me to solve this probelm.
Query
Name | Helen |
Address | Firestone Avenue |
City | Cavespring |
State | Arkansas |
Name | Charles |
Address | Turnbridge Drive |
City | Dallas |
State | Texas |
Required Result
Name | Address | City | State |
Helen | Firestone Avenue | Cavespring | Arkansas |
Charles | Turnbridge Drive | Dallas | Texas |
Solved! Go to Solution.
- Labels:
- Preparation
- Regex
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Sometimes i have different row where i cannot apply the Floor command. In the below table, i have 4 rows belonging to one record and next three rows that belongs to different set of record. how to do a crosstab for this scenario
Query
Name | Helen |
Address | Firestone Avenue |
City | Cavespring |
State | Arkansas |
Name | Charles |
Address | Turnbridge Drive |
City | Dallas |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Thank You for responding to my Query. Can you please explain the meaning of below expression.
[Row-1:RecordID]+IIF([Field1]="Name",1,0)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is a multi-row formula creating a RecordID field eqial to the running count of times Field1 = Name.
[Row-1:ReordID] is the value of the RecordID on the row above. If the first row this will be 0.
IIF(...) is the inline IF function (I personally prefer over IF THEN ELSE ENDIF but no real difference).
The IIF function evaluates to a 1 if Field1 is equal to Name otherwise it is 0.
Hope that makes sense!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You. It is working..
I ran into another issue. Request your help.
I ran the Workflow and generated grouping numbers to transpose the records in proper order. My requirement is to neglected all the Result with Error ( Grouping 2) and take only the Success Records ( Grouping no 1 and 3) and transpose them to a excel sheet. Please help me to solve this problem.
Result | Success | Grouping |
Name | Mike | 1 |
Address | Gravette | 1 |
Result | Error | 2 |
Error Detail | Error out | 2 |
Result | Success | 3 |
Name | Harrison | 3 |
Address | Joplin | 3 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I woudl say the easiest way is to transpose all the records so you have one row per grouping
Then use a filter tool to filter on the Result column. You can then just keep the rows where Result = success
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You. Its is working