StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18321368
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-08-19T19:15:19.803
FavoriteCount
0
LastActivityDate
2013-08-19T19:15:19.803
LastEditDate
LastEditorUserId
0
OwnerUserId
641955
ParentId
18320091
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
The first problem is easy. For each input feed, use a Rename operator rename or copy dom elements to your unified format. Then after you union all your modified input fields, you can use the unified names. The second problem is tricky. I usually work around cases like that by using a Rename + Regex + Loop(String Builder) operators like this: <ol> <li>Rename the relevant fields, just so that they become easier to work with later, for example: <ul> <li>Rename <code>item.div.div.0.div.div.a.href</code> to <code>link0</code></li> <li>Rename <code>item.div.div.1.div.div.a.href</code> to <code>link1</code></li> <li>Rename <code>item.div.div.2.div.div.a.href</code> to <code>link2</code></li> <li>...</li> </ul></li> <li>Using a Regex, try to make the irrelevant <code>link0</code>, <code>link1</code> empty, for example: <ul> <li>In <code>item.link0</code> replace <code>^.*[^/]$</code> with nothing</li> <li>In <code>item.link1</code> replace <code>^.*[^/]$</code> with nothing</li> <li>In <code>item.link2</code> replace <code>^.*[^/]$</code> with nothing</li> <li>...</li> </ul> The right regex will depend on your use case. In my example this was suitable to make the irrelevant elements empty.</li> <li>Using a Loop, with a String Builder inside, I concatenate <code>item.link0</code> and <code>item.link1</code> and assign the result to <code>item.link</code>.</li> </ol> As a result, whichever <code>link0</code>, <code>link1</code>, ... had the right link, since all the others were emptied, the concatenated value will be the right one. It's a hack, but it can work. I actively use this technique in some of my pipes. The tricky part is coming up with the right regex to make the irrelevant values blank.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to two different tags for images from different feeds as one single tag in yahoo pipes?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USjanos
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to two different tags for images from different feeds as one single tag in yahoo pipes?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COI have solved the first problem, but for second problem, I need to find a regex that matches all url from gravatar, all media url that are not in image format and the most tricky, the irrelevant image which have no pattern at all.Anyway, thank you for your answer.I have really appreciated it.
 singulars
 PostPostId
 PO
 UserUserId
 USBiswas Lamichhane

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.