Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

1-3e

0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
In one of the earlier videos, we split this column up into manufacturer name and product code. Product code is the interesting thing as we're looking at product table here. And actually we've ended up now with some redundant data. So my manufacturer name, I've already got a column called manufacturer. I've also got this manufacturer ID, which is a look up to this other table which has also got the name of the manufacturer in it. So we've got a few extra columns that we don't need anymore. And doing things like removing or reordering these columns is really simple. I can right click and remove this column and I can right click and remove the manufacturer column, and now I'm just left with my manufacturer ID. Now, the great thing about the way that this query editor works, and these steps that we're building up in the right hand side is that one of these columns, for example, the product code that was derived from a different column that we were using before, I can remove the source columns and it doesn't actually impact the result. So, if you're using columns to create kind of intermediate steps as you're doing calculations, it's okay to go back and remove those intermediate steps once you're finished. And then that doesn't get loaded to your model to do any further analysis. So, removing columns is easy. Reordering them is also easy, so maybe you want to put all of the manufacturer IDs at the start of the table. So I can just grab the heading and drag it left to right to reorder them. Maybe the important thing for us is to have our products and categories and segments arranged in the right order in the hierarchy, so maybe we have lots of products that are in segments, and the segments are in categories, so let's order them in that way as well. It's easy to drag things around and arrange them. And like you saw, it's really easy to remove columns that you don't need if they're redundant pieces or intermediate steps during your calculations.

Video Details

Duration: 2 minutes
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 30
Posted by: csintl on Aug 15, 2016

see previous note. ----- (Please provide translations for these languages: Chinese (Simplified) (chi_hans), Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus), Spanish (spa).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.