Documentation and SupportV6 User Manual The Fix ToolHow do I create a View Mashup Field? (Version 1.1)

How do I create a View Mashup Field? (Version 1.1)

1. Open the Configuration tool.

TMMData - my.tmmlog.in - Google Chrome

2. Type anything in the Field box and hit enter to add a new field.

For this example, we will type "Mashup View"

TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

3. Find the new field in your list, then click the prep tool.

Notice that the title of this Field shows "Custom SQL 1" (and does NOT show the "mashup view" title that we typed)...

TMMData - my.tmmlog.in - Google Chrome

We can highlight and then type "mashup view" into the title of the Field, at this point...

If we do NOT change this, then the "Custom SQL 1" will be the title that shows at the top of mashup view Column in the Table...

TMMData - my.tmmlog.in - Google Chrome

By typing "mashup view" here, the top of our mashup Column will now be called "mashup view"

TMMData - my.tmmlog.in - Google Chrome

4. Click on the "SQL Value" button to open the Mashup Modal.

Notice that the words "mashup view" that are shown to the left of the <> will appear in the "Value" box on the next step...

Select the <> icon...

TMMData - my.tmmlog.in - Google Chrome

5. Create New Mashup Value

Notice that the "Value" box has the "mashup view" listed in it by default...

TMMData - my.tmmlog.in - Google Chrome

6. Enter what you would like to be in the Mashup field.

This can be as simple as text or a number, or it can be custom SQL.

Note: You can use any of the available options along the top, and you can use any of the fields in the drop down.  If you are going to use plain text or a number, please be sure to use single quotes around your entry as shown below. The hit Save.

The "Value" shown here as "mashup view" is NOT the name of the field, but is the "Value" that the system will try to mashup.

[For example... if you're trying to do a CONCAT(field1,field2) you'd type that in up top and it would appear as the mashup in a field called "Custom SQL 1" ]

 

 

For our example here, we will remove anything shown in the Value box, then type 'complete'...

make sure to use single quotes (') on each side of what you enter, for it to work correctly...

TMMData - my.tmmlog.in - Google Chrome

7. Run your view that contains your Mashup field.

Load your view that contains your Mashup field.

8. Congratulations, your Mashup Field has been added!

TMMData - my.tmmlog.in - Google Chrome
9. Here is an example that goes more in-depth... using the "CONCAT" mashup, this time...

For this example, we will:

1.  Select "CONCAT"...

2. Notice what shows up in the "Value" box, as a result...

TMMData - my.tmmlog.in - Google Chrome

We will then select a Field to Mashup...  

For this example, we will use the "Channel" Field from the drop-down menu...

TMMData - my.tmmlog.in - Google Chrome

We will then select a second Field for the Mashup... using the "Vendor"Field from the drop-down menu...

TMMData - my.tmmlog.in - Google Chrome

Notice the information in the "Value" box, now...

1. CONCAT(?,?)

2. `Channel`

3. `Vendor`

TMMData - my.tmmlog.in - Google Chrome

We need to put the `Channel` and the `Vendor` into a format that works with the CONCAT...

So we will have to manually EDIT what is shown in the "Value" box...

Be sure to use the ( ` ) back-tick on both sides of your Field Title(s)... make sure that it is NOT the single-quote ( ' ) :

CONCAT(`Channel`,`Vendor`)

TMMData - my.tmmlog.in - Google Chrome

As an example to contrast with, we will set up and use a "mashup view 1" as a Field with this formula:

CONCAT('Channel','-','Vendor')

 

Notice that the "mashup view 1" and the "mashup view 2" have completely different results shown!

We CORRECTLY used the back-tick ( ` )  on "mashup view 2"... so it CORRECTLY shows the data from #1 and #2 beside each other...

We did NOT use the back-tick ( ` ) on "mashup view 1"... instead we used the single-quote ( ' )...  so it did NOT show any data from #1 or #2... it simply included the data from inside the single-quotes ( ' ).