Record display
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jmedidi
8 - Asteroid
‎01-25-2022
04:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Need some help to display the existing records as mentioned below:
Files | Calibration | Warnings | DV_Testing_completion_date |
Yes | |||
No | |||
n/a | |||
06.00.05 | |||
033.44.33 | |||
112.3.45 | |||
Yes | |||
No | |||
n/a | |||
12-Jun-20 | |||
8-Aug-20 | |||
21-Jan-22 |
Desired
Files | Calibration | Warnings | DV_Testing_completion_date |
Yes | 06.00.05 | Yes | 12-Jun-20 |
No | 033.44.33 | No | 8-Aug-20 |
n/a | 112.3.45 | n/a | 21-Jan-22 |
Labels:
- Labels:
- Developer Tools
7 REPLIES 7
MatthewO
Alteryx Alumni (Retired)
‎01-25-2022
05:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thableaus
17 - Castor
‎01-25-2022
05:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
atcodedog05
22 - Nova
‎01-25-2022
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-25-2022
06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have more than 4 columns
messi007
15 - Aurora
‎01-25-2022
06:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-25-2022
10:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Works well. But i see lot of blank rows below after the contents moved. I tried Data cleansing tool to remove Null rows but looks like it doesn't work to remove the blank rows. also i can also use filter to remove empty rows but there are more than 60 fields to work.
gabrielvilella
14 - Magnetar
‎01-25-2022
01:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can filter on one field that if that one is blank, you know that all the other are blank and should be removed. Or if you want to use the data cleansing too, you can have a multi field formula before like this:
IF IsEmpty([_CurrentField_]) THEN Null() ELSE [_CurrentField_] ENDIF